Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)
Previous Next
Subject: Copy Selected as Table and 22.75 inch limits - A way to test?
Feedback Type: Question
Product Area: Notes Client
Technical Area: Functionality
Platform: Windows
Release: 8.5.2
Reproducible: Always

Actual client version 8.5.2FP3

After using a Lotus Script agent from years ago to export data from a view, I discovered a few limitations. We are in the process of taking data from a Notes based application and entering it into a Relational database. To help export the data out we were using the typical "Export to 1-2-3 and then open in Excel" or the agent I just mentioned that writes directly from the view columns to the Excel sheet. The issue comes in that there are some "constants" in our view as these are data required by the new system only and are not directly stored on the document. The agent skips these columns when running.

As a work around I've come up with a way to use the "Copy Selected as Table" and then open a new Excel spreadsheet and "paste" the contents there. The issue is that some of the views are larger than 22.75 inches and we get only the display on the status bar and the resulting view copy/paste is lacking some of the columns. We can manually "compress" the columns until they are all copied, but it must be done each time manually.

Question 1 - is there a way to check if the columns shown would result in over 22.75 inches when copied as a table? If could know before I could at least warn the user to shrink the columns a bit (@Formula, LS?).

Question 2 - is there a way to automatically adjust the columns on the fly to ensure they all fit on the resulting table.

If anyone is interested in the two part action of 1) copy selected as table and 2) create a new Excel File, paste and format) I'll be glad to post that.

Thanks!
Chuck


Feedback number WEBB8RVQG2 created by ~Vanessa Minjumitheroni on 02/27/2012

Status: Open
Comments:

Copy Selected as Table and 22.75 in... (~Vanessa Minjum... 27.Feb.12)
. . Write it direct from docs to file (~Fritz Quethipi... 28.Feb.12)
. . . . Values are only in view, not on doc... (~Vanessa Minjum... 28.Feb.12)
. . . . . . or parse the view's Columns and... (~Fred Asatumibu... 1.Mar.12)
. . . . . . . . parse the column and evaluate formu... (~Vanessa Minjum... 1.Mar.12)
. . . . . . If it's a constant... (~Fritz Quethipi... 29.Feb.12)
. . . . . . . . Constant in script - don't wanna do... (~Vanessa Minjum... 1.Mar.12)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS